18,283 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
3 answers

Maintaining tablix width when hiding some columns in rdlc report

In our project, we got some rdl files that contains dynamic column, User can decide which to show or which to hide by a Multi-Selection Report Parameter. then it comes some problems: 1.if there is a report contains 10 columns, when the user selected 5…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,845 questions
asked 2020-08-28T10:27:36.42+00:00
akshay kumar 1 Reputation point
answered 2020-09-02T06:16:26.42+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

AlwaysOne see all the bases on the primary server? Why?

Hi, when i access a listerner i see all the bases of the primary server. I notice that I see the base that was synchronized and also all the others that were not synchronized. Is that so by design? Did I imagine that it would only show the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-31T01:53:26.717+00:00
Salves 501 Reputation points
commented 2020-09-02T06:10:18.767+00:00
CathyJi-MSFT 21,106 Reputation points Microsoft Vendor
2 answers

SQL 2017 Scheduled Maintenance Plan job

I created a reoccurring scheduled SQL maintenance job with my login account (myNetwork\myUsername) but the it fails each time. The Windows Application log states that the following: SQL Server Scheduled Job 'MaintenancePlan_FULL_Backup.Subplan' -…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-29T15:45:09.28+00:00
kescott 21 Reputation points
commented 2020-09-02T05:47:39.237+00:00
Cris Zhan-MSFT 6,611 Reputation points
5 answers

SQL Server: Restoring database from a remote location directly vs. copy .bak file and then restore

SQL Server: Restoring database from a remote location directly vs. copy .bak file and then restore Will anybody know why restoring directly from a LAN location is far faster than the total time require for copying the .bak file first and then…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-27T23:41:29.643+00:00
travisGatesMcGee@hotmail.com 21 Reputation points
commented 2020-09-02T05:43:18.897+00:00
Cris Zhan-MSFT 6,611 Reputation points
3 answers One of the answers was accepted by the question author.

Unable to install sql server 2017 developer editiion x64 windows 10 Pro

Need Help with Following Error : 21623-summary-etpld023-20200831-202936.txtMicrosoft SQL Server 2017 Setup ------------------------------ The following error has occurred: There is a problem with this Windows Installer package. A DLL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-31T15:07:48.39+00:00
Ravi G Singh 21 Reputation points
commented 2020-09-02T04:50:21.14+00:00
Ravi G Singh 21 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Serverログオン不可が頻発（Error: 17189, Severity: 16, State: 1.）

【環境】 Microsoft Windows Server 2012 R2 Standard DBサーバーに対しSQL Serverの最大サーバメモリは、4096(MB)を設定しております。 ---systeminfo--- 物理メモリの合計: 8,191 MB 利用できる物理メモリ: 1,168 MB 仮想メモリ: 最大サイズ: 13,162 MB 仮想メモリ: 利用可能: 3,419 MB 仮想メモリ: 使用中: 9,743 MB 【質問内容】 …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-09-01T01:21:10.083+00:00
悠 高島 81 Reputation points
answered 2020-09-02T00:49:52.437+00:00
悠 高島 81 Reputation points
4 answers One of the answers was accepted by the question author.

How can i deny access to any sql management from lan and public network?

Hello, Can i deny access to any sql management from lan and public network? I mean the user SA to be able to be used to read and write in the bases but not to connect with the sql management or similar app. Thank you, Giorgos

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-30T16:20:32.52+00:00
Stefanos Spyridakis 21 Reputation points
commented 2020-09-01T21:17:21.167+00:00
Erland Sommarskog 102.9K Reputation points
2 answers

SSRS Email settings

Hi, SQL Server 2012 Standard I dont see the column for entering authentication details for smtp server under email settings of SQL Reporting server configuration window. I edited the configuration file and added the userName and Password tags in…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,845 questions
asked 2020-08-18T18:02:46.327+00:00
Ashru 41 Reputation points
commented 2020-09-01T15:11:41.197+00:00
Ashru 41 Reputation points
2 answers One of the answers was accepted by the question author.

Query to find list of all primary keys and check if they are clustered and if they are on uniqueidentifier column

Dear Experts, I have this requirement to query all the tables in my database to check if the tables have clustered indexes on the primary key and if the key column is an uniqueidentifier. I prepared this script below select o.name as TableName ,…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,571 questions
asked 2020-09-01T11:16:02.677+00:00
mo boy 396 Reputation points
commented 2020-09-01T13:01:50.353+00:00
Dan Guzman 9,216 Reputation points
1 answer

Multidimensional Project Data Source Wizard Fail SSAS

Hello, I'm trying to create a data cube in Visual Studio (SSDT) and I'm unable to launch Data Source Wizard. When I select New Data Source, I see the wizard, but when I click Next, the wizard dissapears. Has anyone faced such issue? Could this be…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
asked 2020-08-24T06:15:44.097+00:00
Green Tree 1 Reputation point
commented 2020-09-01T09:17:26.403+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Suppress Zeros and Empty Rows and Columns by using MDX

Hi, following is my MDX. Still getting zero rows and columns. how to remove zero rows and columns. Select Non Empty CrossJoin( CrossJoin( {{[Account].& [1]}, {[Account].& [2]}, {[Account].& [3]}}, {{[Measures].[YTD]}, …

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
asked 2020-08-24T12:16:55.68+00:00
Narendra Reddy 1 Reputation point
commented 2020-09-01T09:13:34.507+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Calcualte Sum(Price) Ignoring one level

I need to create a measure which will group by vendorname and account name and pick max price and sum price at vendor level and account level ignore subaccount level. Create Derived table as shown in excel and do sum of price on derived table …

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions
asked 2020-08-27T00:08:14.97+00:00
Ra 1 Reputation point
commented 2020-09-01T09:07:51.767+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

SUM and JOIN 2 columns with different tables but it duplicates results

Good day! Need help re SUM and JOIN 2 columns with different tables but it duplicates results here's the sample data tables; here's my sql query code SELECT MAX([BBI$Transfer Shipment Line].[Transfer-to Code]) AS [Loc Code] …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,571 questions
asked 2020-08-28T07:28:26.103+00:00
glennyboy 121 Reputation points
commented 2020-09-01T07:37:45.653+00:00
Viorel 113.7K Reputation points
5 answers

SCOM 2012 Restored from Backup

Hi, Recently my SCOM 2012 and its SQL database had to be restored from backup due to a disaster that happened. I did a google search to only run some repair commands for SQL, and that's pretty much what I did for the SQL portion. On the Operations…

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,428 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-24T18:45:55.53+00:00
GeniusGab 1 Reputation point
commented 2020-09-01T07:27:37.183+00:00
Crystal-MSFT 44,836 Reputation points Microsoft Vendor
1 answer

Reporting Naming Convention for TFS Project Name and Reporting Manger Folder

Hi All, What is best way to organize your reporting (SSRS Paginated, SSRS Mobile and Power BI) Projects and reports on TFS and Reporting Manger..? I have separate SSRS Project on TFS for each Sub-Folders on Reporting Manager. On Report Manager, I…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,845 questions
asked 2020-09-01T05:08:51.723+00:00
Shivendoo Kumar 736 Reputation points
answered 2020-09-01T07:09:11.54+00:00
Joyzhao-MSFT 15,566 Reputation points
4 answers

How to restore backdata file data from version 8.00.0194 to 14.00.1000?

Hi I have mssql 2017 is running. But I need to restore the backup data from mssql 2008 (8.00.0194) Currently I do not have MSSQL 2008. How can I restore data from old version to New version mssql server? When restore, the error is prompt that is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-28T07:20:56.58+00:00
SILS 61 Reputation points
answered 2020-09-01T07:02:07.01+00:00
m 4,271 Reputation points
1 answer

SSRS Report Execution time different to Schedule Subscription time

Hi everyone. I am having trouble diagnosing an issue with an SSRS schedule. It runs once a week at 0130 but the execution logs suggest it executes regularly around 0146. I have tried the following but I found no clue as to what this may be: …

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,845 questions
asked 2020-08-19T09:29:56.08+00:00
Robin 1 Reputation point
commented 2020-09-01T06:42:06.907+00:00
Joyzhao-MSFT 15,566 Reputation points
3 answers

SQL Server Management Studio 18.x Bug on Open .sql file

Like in any Windows environment you have several options to open a file. Let's say you have all of them in SSMS too. Via internal File->Open menu or by grag-n-dropping a *.sql file to the opened and connected SSMS. The other option is to simply…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-27T03:35:53.923+00:00
A T 1 Reputation point
answered 2020-09-01T06:35:19.77+00:00
m 4,271 Reputation points
3 answers

Filter statistics and recompile

is it a must to execute the query with recompile in order to use filter statistics ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-26T07:21:50.08+00:00
sakuraime 2,321 Reputation points
answered 2020-09-01T06:34:35.833+00:00
m 4,271 Reputation points
7 answers

memoryclerks vs memoryobject vs memory pools

Hi all , just want to know the difference of memory clerks and memory objects and what's are their relationship ? another question is why virtual_memory_committed_kb is much less than pages_kb?? pages_kb is the size that memory clerks…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,015 questions
asked 2020-08-25T03:27:20.543+00:00
sakuraime 2,321 Reputation points
answered 2020-09-01T06:34:14.353+00:00
m 4,271 Reputation points